#5 -- SQL '92
"select * from accounts_payable where
  order_id = NULL"
  //never returns rows!

"select * from accounts_payable where
  order_id is NULL"
  //may returns rows

"select * from accounts_payable where
  order_id = ?"
  // Use setNull for the parameter
  // Will never return rows

Return to Tracks